All Identifiers

Name Unit Description
AxPUCChar XLSUtils5

 

AxUCChar XLSUtils5

 

AxUCString XLSUtils5

 

BoolAsWord XLSUtils5

 

BytesToHexStr XLSUtils5

 

CharInSet XLSUtils5

 

CmToEmu XLSUtils5

 

ComponentName XLSUtils5

 

CopyAllCells XLSSheetData5

What parts of the data on a worksheet that shall be copied/moved.

CPos XLSUtils5

 

CPos XLSUtils5

 

CurrentBuildNumber XLSUtils5

 

CurrentVersionNumber XLSUtils5

 

DefaultDeleteOptions XLSSheetData5

 

ecAssertion XLSRTFReadWrite5

 

ecBadTable XLSRTFReadWrite5

 

ecEndOfFile XLSRTFReadWrite5

 

ecInvalidHex XLSRTFReadWrite5

 

ecOK XLSRTFReadWrite5

 

ecStackOverflow XLSRTFReadWrite5

 

ecStackUnderflow XLSRTFReadWrite5

 

ecUnmatchedBrace XLSRTFReadWrite5

 

EmptyGUID XLSUtils5

 

EmuToCm XLSUtils5

 

EMU_PER_PT XLSUtils5

 

ExportCSV XLSExportCSV5

This routin will export the content of a worksheet to a text (CSV) file. ˜param XLS The XLSReadWriteII object to export. ˜param SheetIndex Index of the work sheet to export. ˜param QuoteChar Quote character for text strings. ˜param SeparatorChar The character used to separate the cell values (fields) in the file. Common used characters are comma, semicolon and tab. ˜param Options File export options. ˜param Filename The name of the file that the cells shall be exported to.

Fork XLSUtils5

 

Fork XLSUtils5

 

FormatSettings XLSUtils5

 

G_Counter XLSUtils5

 

G_DirSepChar XLSUtils5

 

ImportCSV XLSImportCSV5

 

ImportCSV XLSImportCSV5

This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. Correct value for decimal separator is detected automatically. See alse ˜[link ImportCSVAuto] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param SepChar Separator character for the fields (cells) in the source file. ˜param HasQuoteChar Set this to True if strings in the source file are quoted. ˜result The number of cells that where imported.

ImportCSVAuto XLSImportCSV5

This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. The routine will try to detect correct values for separator character, quote character and decimal separator. See alse ˜[link ImportCSV] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜result The number of cells that where imported.

ImportHTMLTable XLSImportHTMLTable5

This routine will import a table <TABLE> tag from a html file into a worksheet. Any existing cells on the worksheet will be overwritten. ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param TableIndex The zero based index of which table (if there is more than one) that shall be imported. If TableIndex is set to -1, all tables will be imported. ˜param SpecialDecode Default set to False. Don't change this. ˜param DecSep Decimal separator character. Default is the Delphi DecimalSeparator global variable value. Change this if numeric values not are imported correct. ˜result True if any cells where imported.

MakeIndent XLSUtils5

 

MakePasswordHash XLSUtils5

 

MAXDOUBLE XLSUtils5

 

MINDOUBLE XLSUtils5

 

NativeInt XLSUtils5

 

PasswordFromHash XLSUtils5

 

PDoubleArray XLSUtils5

 

PixelsPerInchXY XLSUtils5

 

PSAVE XLSRTFReadWrite5

 

RCPos XLSUtils5

 

RCPos XLSUtils5

 

RGBToTColor XLSUtils5

 

RoundToDecimal XLSUtils5

 

SafeTryStrToFloat XLSUtils5

 

SortDoubleArray XLSUtils5

 

SplitAtChar XLSUtils5

 

StrDigits XLSUtils5

 

StreamIsZIP XLSUtils5

 

StripQuotes XLSUtils5

 

TActivePane XLSSheetData5

 

TACTN XLSRTFReadWrite5

 

TAddImageEvent97 XLSDrawing5

 

TBaseCellAreas XLSCellAreas5

Virtual base class for objects that manipulates cell areas.

TCellArea XLSCellAreas5

Represents a cell area.

TCellAreaImpl XLSCellAreas5

 

TCellAreas XLSCellAreas5

Base class for objects that manipulates cell areas.

TCellEdge XLSCellAreas5

 

TCellEdges XLSCellAreas5

 

TCellRef XLSCellAreas5

 

TCellRefs XLSCellAreas5

 

TCHP XLSRTFReadWrite5

 

TCmdBorderSide XLSCmdFormat5

 

TCmdBorderSidePreset XLSCmdFormat5

 

TCmdBorderSides XLSCmdFormat5

 

TCmdFmtFillProp XLSCmdFormat5

 

TCmdFmtFontProp XLSCmdFormat5

 

TCmdFmtObject XLSCmdFormat5

 

TCmdFmtXFProp XLSCmdFormat5

 

TCmdTriState XLSCmdFormat5

 

TColorToRGB XLSUtils5

 

TCopyCellsOption XLSSheetData5

Options when copying and moving cells.

TCopyCellsOptions XLSSheetData5

Copy merged cells.

TDOP XLSRTFReadWrite5

 

TDoubleArray XLSUtils5

 

TDrwOptImagePositioning XLSDrawing5

 

TDynDoubleArray XLSUtils5

 

TExportCSVOption XLSExportCSV5

Options when exporting to CSV files.

TExportCSVOptions XLSExportCSV5

Write the formulas to the file, instead of the values (result) of the formulas.

TFormatSettings XLSUtils5

 

TIDEST XLSRTFReadWrite5

 

TIndexFont XLSRTFReadWrite5

 

TIndexFontList XLSRTFReadWrite5

 

TIndexObject XLSUtils5

 

TIndexObjectList XLSUtils5

 

TIntegerEvent XLSUtils5

 

TIntegerList XLSUtils5

 

TIntegerStack XLSUtils5

 

TIPFN XLSRTFReadWrite5

 

TIPROP XLSRTFReadWrite5

 

TJust XLSRTFReadWrite5

 

TKWD XLSRTFReadWrite5

 

TPaneType XLSSheetData5

Pane type when a worksheet has splitted panes.

TPAP XLSRTFReadWrite5

 

TPGN XLSRTFReadWrite5

 

TPointerMemoryStream XLSUtils5

 

TPrintSetupOption XLSSheetData5

Cell values Drawing shapes. Cell notes. Conditional formats. Cell validations. Merged cells.

TPrintSetupOptions XLSSheetData5

 

TPROP XLSRTFReadWrite5

 

TPROPTYPE XLSRTFReadWrite5

 

TRDS XLSRTFReadWrite5

 

TRIS XLSRTFReadWrite5

 

TRoundToEXRangeExtended XLSUtils5

 

TRtfFont XLSRTFReadWrite5

 

TRtfFonts XLSRTFReadWrite5

 

TRTFReader XLSRTFReadWrite5

 

TRTFStack XLSRTFReadWrite5

 

TRTFStackItem XLSRTFReadWrite5

 

TryCurrencyStrToFloat XLSUtils5

 

TSAVE XLSRTFReadWrite5

 

TSBK XLSRTFReadWrite5

 

TSelectedAreaHit XLSSheetData5

 

TSelectedEdgeHit XLSSheetData5

 

TSelectedEdgeHits XLSSheetData5

 

TSEP XLSRTFReadWrite5

 

TSolidCellAreas XLSCellAreas5

Base class for objects that manipulates cell areas. Solid areas are areas that not can be splitted by delete/insert/move operations, such as merged cells.

TStringEvent XLSUtils5

 

TSysCharSet XLSUtils5

 

TTABLEProperties XLSExportHTML5

Settings for the tables created on the destionation file.

TTwoIntegerEvent XLSUtils5

 

TWorkbookOption XLSSheetData5

 

TWorkbookOptions XLSSheetData5

The workbook tabs are displayed.

TWorkspaceOption XLSSheetData5

 

TWorkspaceOptions XLSSheetData5

Outline symbols are displayed.

TXLSAutofilter XLSAutofilter5

 

TXLSCell XLSFormattedObj5

 

TXLSCellSortItem XLSSheetData5

 

TXLSCFRule XLSCondFormat5

 

TXLSCFRules XLSCondFormat5

 

TXLSClassFactoryImpl XLSReadWriteII5

 

TXLSCmdFormat XLSCmdFormat5

 

TXLSCmdFormatAlignment XLSCmdFormat5

 

TXLSCmdFormatBorder XLSCmdFormat5

 

TXLSCmdFormatColor XLSCmdFormat5

 

TXLSCmdFormatFill XLSCmdFormat5

 

TXLSCmdFormatFont XLSCmdFormat5

 

TXLSCmdFormatMode XLSCmdFormat5

 

TXLSCmdFormatNumber XLSCmdFormat5

 

TXLSCmdFormatProtection XLSCmdFormat5

 

TXLSColumn XLSColumn5

 

TXLSColumns XLSColumn5

Methods for manipulating columns. Please note that these methods has no affect on the cell values. They operate only on the columns heading.

TXLSComment XLSComment5

 

TXLSComments XLSComment5

 

TXLSConditionalFormat XLSCondFormat5

 

TXLSConditionalFormats XLSCondFormat5

 

TXLSDataSetList XLSDbRead5

˜exclude

TXLSDataValidation XLSValidate5

 

TXLSDataValidations XLSValidate5

 

TXLSDbCellEvent XLSDbRead5

Event fired when ˜[link TXLSDbRead4] reads a cell. ˜param Sender The TXLSDbRead4 object. ˜param IsFieldNames True if the cell is a field name. ˜param Dataset The source data set. ˜param FieldIndex Index into the source data set's field list. ˜param Col The column in the destination XLSReadWriteII object where the cell is inserted. ˜param Row The row in the destination XLSReadWriteII object where the cell is inserted.

TXLSDbRead5 XLSDbRead5

Component for importing data sets (TDataset) into a XLSReadWriteII component.

TXLSDbRecordEvent XLSDbRead5

 

TXLSDefaultFormat XLSCmdFormat5

 

TXLSDefaultFormats XLSCmdFormat5

 

TXLSDeleteOption XLSSheetData5

 

TXLSDeleteOptions XLSSheetData5

 

TXLSDrawing XLSDrawing5

 

TXLSDrawingChart XLSDrawing5

 

TXLSDrawingCharts XLSDrawing5

 

TXLSDrawingEditor XLSDrawing5

 

TXLSDrawingEditorShape XLSDrawing5

 

TXLSDrawingEditorTextBox XLSDrawing5

 

TXLSDrawingImage XLSDrawing5

 

TXLSDrawingImages XLSDrawing5

 

TXLSDrawingObject XLSDrawing5

 

TXLSDrawingObjects XLSDrawing5

 

TXLSDrawingShape XLSDrawing5

 

TXLSDrawingShapes XLSDrawing5

 

TXLSDrawingTextBox XLSDrawing5

 

TXLSDrawingTextBoxes XLSDrawing5

 

TXLSDrawingWordArt XLSDrawing5

 

TXLSDrawingWordArts XLSDrawing5

 

TXLSDrwColor XLSDrawing5

 

TXLSDrwColorType XLSDrawing5

 

TXLSDrwFill XLSDrawing5

 

TXLSDrwFillChoice XLSDrawing5

 

TXLSDrwFillGradient XLSDrawing5

 

TXLSDrwFillGradientStop XLSDrawing5

 

TXLSDrwFillGradientStops XLSDrawing5

 

TXLSDrwFillNone XLSDrawing5

 

TXLSDrwFillPictStretchOpts XLSDrawing5

 

TXLSDrwFillPictTileOpts XLSDrawing5

 

TXLSDrwFillPicture XLSDrawing5

 

TXLSDrwFillSolid XLSDrawing5

 

TXLSDrwFillType XLSDrawing5

 

TXLSDrwGradientFillDirection XLSDrawing5

 

TXLSDrwGradientFillType XLSDrawing5

 

TXLSDrwLineEndStyle XLSDrawing5

 

TXLSDrwLineFillChoice XLSDrawing5

 

TXLSDrwLineJoinType XLSDrawing5

 

TXLSDrwLineStyle XLSDrawing5

 

TXLSDrwMirrorType XLSDrawing5

 

TXLSDrwShapeProp XLSDrawing5

 

TXLSDrwShapeProperies XLSDrawing5

 

TXLSDrwTextAlign XLSDrawing5

 

TXLSDrwTextBody XLSDrawing5

 

TXLSDrwTextFont XLSDrawing5

 

TXLSDrwTextPara XLSDrawing5

 

TXLSDrwTextParas XLSDrawing5

 

TXLSDrwTextRun XLSDrawing5

 

TXLSDrwTextRuns XLSDrawing5

 

TXLSDrwTwoPosShape XLSDrawing5

 

TXLSDrwXMLColorType XLSDrawing5

 

TXLSErrorEvent XLSUtils5

 

TXLSErrorLevel XLSUtils5

 

TXLSErrorLevels XLSUtils5

 

TXLSErrorManager XLSUtils5

 

TXLSExport5 XLSExport5

Base class for objects that exports TXLSReadWriteII data to other file formats.

TXLSExportHTML5 XLSExportHTML5

Exports a workbook to a HTML file. On the destionation file one table is created for each worksheet of the source TXLSReadWriteII object.

TXLSExportOption XLSExport5

 

TXLSExportOptionHTML XLSExportHTML5

 

TXLSExportOptions XLSExport5

 

TXLSExportOptionsHTML XLSExportHTML5

 

TXLSFormattedObj XLSFormattedObj5

 

TXLSHeaderFooter XLSSheetData5

 

TXLSHorizPagebreak XLSSheetData5

 

TXLSHorizPagebreaks XLSSheetData5

 

TXLSHyperlink XLSHyperlinks5

 

TXLSHyperlinks XLSHyperlinks5

 

TXLSImportSYLK XLSImportSYLK5

 

TXLSMergedCell XLSMergedCells5

 

TXLSMergedCells XLSMergedCells5

 

TXLSMoveCopyItem XLSMoveCopy5

 

TXLSMoveCopyList XLSMoveCopy5

 

TXLSName XLSNames5

 

TXLSNames XLSNames5

 

TXLSNames_Int XLSNames5

 

TXLSOptionsDialog XLSSheetData5

 

TXLSPageBreaks XLSSheetData5

 

TXLSPane XLSSheetData5

 

TXLSPrintSettings XLSSheetData5

 

TXLSProgressEvent XLSUtils5

 

TXLSProgressState XLSUtils5

 

TXLSProgressType XLSUtils5

 

TXLSReadWriteII5 XLSReadWriteII5

 

TXLSRectXY XLSUtils5

 

TXLSRow XLSRow5

 

TXLSRows XLSRow5

 

TXLSRTFWriter XLSRTFReadWrite5

 

TXLSSelectedArea XLSSheetData5

 

TXLSSelectedAreas XLSSheetData5

 

TXLSSheetOption XLSSheetData5

 

TXLSSheetOptions XLSSheetData5

Show zero values.

TXLSSheetProtection XLSSheetData5

 

TXLSValidationOption XLSValidate5

Validation options.

TXLSValidationOptions XLSValidate5

Show an error message when an invalid value is entered. Set of validation options.

TXLSVertPagebreak XLSSheetData5

 

TXLSVertPagebreaks XLSSheetData5

 

TXLSWorkbook XLSSheetData5

 

TXLSWorkbookData XLSSheetData5

 

TXLSWorksheet XLSSheetData5

 

TXLSWriteSheetData XLSWriteXLSX5

 

TXLSWriteXLSX XLSWriteXLSX5

 

UnicodeIs8Bit XLSUtils5

 

XLS8Char XLSUtils5

 

XLS8PChar XLSUtils5

 

XLS8String XLSUtils5

 

XLSCalcCRC32 XLSUtils5

 

XLSERR_BIFF_BADBUILTIN_NAME XLSUtils5

 

XLSERR_BIFF_CANT_FIND_BUILTIN_NAME XLSUtils5

 

XLSERR_DIRECTWR_CELL_NOT_INC XLSUtils5

 

XLSERR_FILENAME_IS_MISSING XLSUtils5

 

XLSERR_FILEREAD_PASSWORDMISSING XLSUtils5

 

XLSERR_FILEREAD_UNKNOWENCRYPT XLSUtils5

 

XLSERR_FILEREAD_WRONGPASSWORD XLSUtils5

 

XLSERR_FILEREAD_XMLPARSE XLSUtils5

 

XLSERR_FMLA_BADARRAYCOLS XLSUtils5

 

XLSERR_FMLA_BADARRAYCONST XLSUtils5

 

XLSERR_FMLA_BADCELLREF XLSUtils5

 

XLSERR_FMLA_BADERRORCONST XLSUtils5

 

XLSERR_FMLA_BADEXPONENT XLSUtils5

 

XLSERR_FMLA_BADFRACTIONAL XLSUtils5

 

XLSERR_FMLA_BADR1C1REF XLSUtils5

 

XLSERR_FMLA_BADSHEETNAME XLSUtils5

 

XLSERR_FMLA_BADTABLE XLSUtils5

 

XLSERR_FMLA_BADUSEOFOP XLSUtils5

 

XLSERR_FMLA_BADUSEOFTABLEOP XLSUtils5

 

XLSERR_FMLA_BADUSEOFTBLSPEC XLSUtils5

 

XLSERR_FMLA_BADWORKBOOKNAME XLSUtils5

 

XLSERR_FMLA_FORMULA XLSUtils5

 

XLSERR_FMLA_INVALIDUSEOF XLSUtils5

 

XLSERR_FMLA_MISSING XLSUtils5

 

XLSERR_FMLA_MISSINGARG XLSUtils5

 

XLSERR_FMLA_MISSINGEXPR XLSUtils5

 

XLSERR_FMLA_MISSINGOPERAND XLSUtils5

 

XLSERR_FMLA_MISSINGQUOTE XLSUtils5

 

XLSERR_FMLA_MISSINGRPAR XLSUtils5

 

XLSERR_FMLA_TABLESQBRACKET XLSUtils5

 

XLSERR_FMLA_TBLSPECNOTFIRST XLSUtils5

 

XLSERR_FMLA_TOMANYGARGS XLSUtils5

 

XLSERR_FMLA_UNKNOWNNAME XLSUtils5

 

XLSERR_FMLA_UNKNOWNSHEET XLSUtils5

 

XLSERR_FMLA_UNKNOWNTABLE XLSUtils5

 

XLSERR_FMLA_UNKNOWNTABLECOL XLSUtils5

 

XLSERR_FMLA_UNKNOWNTBLSPEC XLSUtils5

 

XLSERR_FMLA_UNKNOWNXBOOK XLSUtils5

 

XLSERR_HLINK_INVALID_CELLREF XLSUtils5

 

XLSERR_INVALID_SIMPLE_TAG XLSUtils5

 

XLSERR_NAME_DUPLICATE XLSUtils5

 

XLSERR_NAME_EMPTY XLSUtils5

 

XLSERR_NO_XLS_DEFINED XLSUtils5

 

XLSHINT_BAD_FORMULA_RESULT XLSUtils5

 

XLSRoundTo XLSUtils5

 

XLSWARN_CAN_NOT_CHANGE_MERGED XLSUtils5

 

XLSWARN_CIRCULAR_FORMULA XLSUtils5

 

XLSWARN_IMAGEERROR XLSUtils5

 

XLSWARN_INVALIDCELLREF XLSUtils5

 

XLSWARN_INVALIDCELLVALUE XLSUtils5

 

XLSWARN_MULTIPLE_SEL_AREAS XLSUtils5

 

XLSWARN_SHAPE_CAN_NOT_EDIT XLSUtils5

 

XLSWARN_SHAPE_EDIT_TEXTBOX XLSUtils5

 

XLSWARN_UNKNOWNIMAGE XLSUtils5

 

XLSWARN_UNSUPPORTEDIMAGE XLSUtils5

 

XLSWARN_USEDSHEETNAME XLSUtils5

 

XLSWARN_WORKBOOK_NOT_EMPTY XLSUtils5

 

XLS_MININT XLSUtils5

 

_XLSReplaceStr XLSUtils5

 


Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48